package com.sinosoft.perfect.system._roleBusiness.dao;

import java.sql.SQLException;
import java.util.List;

import com.sinosoft.perfect.system._.po.TRoleBusiness;
import com.sinosoft.perfect.system._roleBusiness.vo.AllUsersInOneRoleBusinessVO;
import com.sinosoft.perfect.system._roleBusiness.vo.RoleBusinessVO;

public interface IRoleBusinessDAO {

	public Object insertByTRoleBusiness(TRoleBusiness troleBusiness) throws SQLException;

	public List<TRoleBusiness> selectByTRoleBusiness(TRoleBusiness troleBusiness, int startIndex, int endIndex) throws SQLException;

	public List<TRoleBusiness> selectByTRoleBusiness(TRoleBusiness troleBusiness) throws SQLException;

	public List<RoleBusinessVO> selectTRoleBusinessFromUnit(String unitId) throws SQLException;

	public List<RoleBusinessVO> selectTRoleBusinessFromUser(String userId) throws SQLException;

	public Object selectTRoleBusinessSortNum(String roleBusinessId) throws SQLException;

	public int updateTRoleBusinessByPrimaryKey(TRoleBusiness troleBusiness) throws SQLException;

	public int updateTRoleBusinessNotNullByPrimaryKey(TRoleBusiness troleBusiness) throws SQLException;

	public int deleteTRoleBusinessByPrimaryKey(TRoleBusiness troleBusiness) throws SQLException;

	public Object selectTRoleBusinessMAXSortNum() throws SQLException;

	public int deleteTRoleBusinessUserByRoleBusinessPrimaryKey(TRoleBusiness troleBusiness) throws SQLException;

	public List<AllUsersInOneRoleBusinessVO> selectExitsUsers(TRoleBusiness tRoleBusiness) throws SQLException;
}
